package org.ezplatform.office.rd.psyj.dao;

import org.ezplatform.core.dao.jpa.JpaBaseDao;
import org.ezplatform.office.rd.psyj.entity.LogEntity;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;


/**
 * @program:
 * @description: dao层
 * @author: zengls
 * @create: 2021-09-07 17:43
 **/
@Repository("logDao")
public abstract interface LogDao extends JpaBaseDao<LogEntity, String>{

    //查询日志相关数据
    @Query(value="select bpm.content ypsyj,bpm.user_name ypsyjpsr,aci.ext_title lcbt,aci.ext_startusername lcngr,aci.ext_category bz,bpm.signtime signtime from BPM_PROCESS_COMMENT bpm,ACT_HI_PROCINST aci where aci.id_=bpm.processinstance_id and bpm.id=?1",nativeQuery = true)
    public abstract List<Map> getList(String num);







}
